Skip to main content Skip to complementary content

Homogeneous replication

The following section describes how Replicate handles replication from Microsoft SQL Server to Microsoft SQL Server-based targets.

In homogeneous replication, source column and table collations will be replicated to the target as described in Column and table collation.

Information note

In homogeneous replication, the source data first passes through the Qlik Replicate data type and is therefore subject to any limitations of that type.

For information on Replicate data types and their limitations (where relevant), see Replicate data types.

For information on which Replicate data types the source data passes through when replicating from Microsoft SQL Server, see the Microsoft SQL Server to Qlik Replicate data types mapping table described earlier.

Information note

To prevent data truncation when replicating columns with an XML data type, it is strongly recommended to enable the Allow unlimited LOB size option in the task settings.

Data type exceptions

When replicating from Microsoft SQL Server database to an SQL Server-based target, source and target data types are identical for all supported Microsoft SQL Server versions, with the following exceptions:

Data type exceptions in homogeneous replication
Microsoft SQL Server Source SQL Server-based Target

VARCHAR

VARCHAR (x)

(when x=0 or x>8000)

else VARCHAR (max)

NVARCHAR (length)

NVARCHAR (x)

(when x=0 or x>8000)

else NVARCHAR (max)

VARBINARY

VARBINARY (x)

(when x=0 or x>8000)

else VARBINARY (max)

HIERARCHYID

VARCHAR (x)

TIMESTAMP

VARBINARY

Column and table collation

When replicating from Microsoft SQL Server to an SQL Server-based target, column and table collations will be replicated to the target.

Information note

To support collation replication, the DBA must ensure that the collations defined for the source Microsoft SQL Server database are the same as those defined for the SQL Server-based target database.

Non-nullable columns and primary/unique index names

Primary/Unique Index names are preserved during homogeneous replication. Non-nullable columns are also preserved during homogeneous replication, with the exception of the following data types:

  • text
  • ntext1
  • varchar(max)
  • nvarchar(max)
  • varbinary(max)
  • image
  • xml

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!